Parallel Cache Management of a RDBMS 1
نویسندگان
چکیده
Increasing requirements such as higher transaction rates, shorter response times etc., make it necessary to parallelize existing database management systems and to implement them on multiprocessors. Shared memory multiprocessors are not arbitrarily scalable, and thus do not meet future requirements. Therefore, it makes sense to implement databases on large-scale distributed memory multicomputers. This raises the problem how to implement a database cache using shared memory concepts extensively under such a hardware architecture. We describe a solution to this problem by introducing a virtual database cache (VDBC). The VDBC is an algorithmic approach based on the concepts of a virtual shared memory and of explicit synchronization. Our approach is based on the assumption, that interprocessor communication is quite favorable as compared to I/O it is thus interesting to exchange pages with other processors instead of with the disks.
منابع مشابه
SQL Query To Trigger Translation: A Novel Consistency Technique for Cache Augmented SQL Systems
Middle-tier caches enhance the performance of applications that exhibit a high read to write ratio and employ a Relational Database Management System (RDBMS). Typically, the cache is a Key Value Store (KVS) that stores and retrieves key-value pairs computed using the normalized tabular data. An example KVS is memcached in use by very large well known sites such as Facebook. A challenge of Cache...
متن کاملTRANSPARENT CONSISTENCY IN CACHE AUGMENTED DATABASE MANAGEMENT SYSTEMS by Jason Yap A Dissertation Presented to the FACULTY OF THE USC GRADUATE SCHOOL UNIVERSITY OF SOUTHERN CALIFORNIA In Partial Fulfillment of the Requirements for the Degree DOCTOR OF PHILOSOPHY
Cache Augmented Database Management Systems (CADBMSs) enhance the performance of simple operations that exhibit a high read to write ratio, e.g., interactive social networking actions. They are realized by extending a data store such as a Relational Database Management Systems (RDBMS) with a Key Value Store (KVS). At the time of writing, memcached is a popular in-memory KVS in use by a number o...
متن کاملWreC: A Scalable Middleware Architecture to Enable XML Caching for Web-Services
Web service caching, i.e., caching the responses of XML web service requests, is needed for designing scalable web service architectures. Such caching of dynamic content requires maintaining the caches appropriately to reflect dynamic updates to the back-end data source. In the database, especially relational, context, extensive research has addressed the problem of incremental view maintenance...
متن کاملLetter from the Editor - in - Chief Bulletin Matters
In-memory databases can provide a significant performance advantage over disk-oriented databases since they avoid disk IO, and since their storage managers are built and optimized for complete memory residency. In this paper we describe the functionality of the Oracle TimesTen In-Memory Database – a full-featured memory optimized relational database. With SQL-92 and ACID compliance, TimesTen is...
متن کاملDesign of the 64-bit Option for the Oracle7 Relational Database Management System
Historically, the limiting factor for the Oracle7 relational database management system (RDBMS) performance on any given platform has been the amount of computational and I/O resources available on a single node. Although CPUs have become faster by an order of magnitude over the last several years, I/O speeds have not improved commensurately. For instance, the Alpha CPU clock speed alone has in...
متن کاملذخیره در منابع من
با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید
عنوان ژورنال:
دوره شماره
صفحات -
تاریخ انتشار 1992